Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# TIMED_STATISTICS

Property | Description
--- | ---
Parameter type | Boolean
Default value | If `STATISTICS_LEVEL` is set to `TYPICAL` or `ALL`, then `true` If `STATISTICS_LEVEL` is set to `BASIC`, then `false`
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`
Range of values | `true | false`

`TIMED_STATISTICS` specifies whether or not statistics related to time are collected.

Values:

- `true`

  The statistics are collected and stored in trace files or displayed in the `V$SESSTATS` and `V$SYSSTATS` dynamic performance views.

- `false`

  The value of all time-related statistics is set to zero. This setting lets Oracle avoid the overhead of requesting the time from the operating system. Normally, `TIMED_STATISTICS` should be `false`.

On some systems with very fast timer access, Oracle might enable timing even if this parameter is set to `false`. On these systems, setting the parameter to `true` can sometimes produce more accurate statistics for long-running operations.

See Also: Oracle Database Performance Tuning Guide for more information on setting this parameter and on performance diagnostic tools in general Appendix E, "Statistics Descriptions" indicates which statistics depend on the setting of this parameter.